package com.base.taskreports.reports.dao.jfu;

import java.util.List;

import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Param;

import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.base.taskreports.reports.entiyt.jfu.TblCqpntPointOutFlowEnyity;

/**
 * <p>
 *  Mapper 接口
 * </p>
 *
 * @author 张玉涛
 * @since 2021-11-09
 */
@Mapper
public interface TblCqpntPointOutFlowDao extends BaseMapper<TblCqpntPointOutFlowEnyity> {

	List<TblCqpntPointOutFlowEnyity> selectExternalIntegralAcceptanceAmountFloatingAlarm();

	List<TblCqpntPointOutFlowEnyity> selectRatioIndicatorMonitorsFloatingAlarmOfExternalIntegralAcceptanceAmount();

	List<TblCqpntPointOutFlowEnyity> selectFloatingProportionOfTheNumberOfPaymentProductsIConsumptionOfEachCreditCategory(@Param(value = "jfsfzDayTabName") String jfsfzDayTabName,@Param(value = "yestoyyyymmddday") String yestoyyyymmddday,@Param(value = "floSt") String floSt);

	List<TblCqpntPointOutFlowEnyity> selectFloatingProportionProductTypeConsumptionRachCreditCategory(@Param(value = "jfsfzDayTabName") String jfsfzDayTabName,@Param(value = "yestoyyyymmddday") String yestoyyyymmddday,@Param(value = "floSt") String floSt);

	List<TblCqpntPointOutFlowEnyity> selectFloatingProportionAmountRachTypeProductPaidConsumptionPointsNumberTransaction(@Param(value = "jfsfzDayTabName") String jfsfzDayTabName,@Param(value = "yestoyyyymmddday") String yestoyyyymmddday,@Param(value = "floSt") String floSt);

	List<TblCqpntPointOutFlowEnyity> selectTheProportionOfReverseTransactionAmountIntegralRevocationFluctuates(@Param(value = "jfsfzDayTabName") String jfsfzDayTabName,@Param(value = "yestoyyyymmddday") String yestoyyyymmddday,@Param(value = "floSt") String floSt);

	List<TblCqpntPointOutFlowEnyity> selectMarketingSystemCuccessRate(@Param(value = "jfsfzDayTabName") String jfsfzDayTabName,@Param(value = "yestoyyyymmddday") String yestoyyyymmddday,@Param(value = "floSt") String floSt);

	List<TblCqpntPointOutFlowEnyity> selectTheConversionValueRatioOfPointsIsNotSingleNumber(@Param(value = "jfsfzDayTabName") String jfsfzDayTabName,@Param(value = "yestoyyyymmddday") String yestoyyyymmddday,@Param(value = "floSt") String floSt);

	List<TblCqpntPointOutFlowEnyity> selectFloatingRateExpiredPoints(String string, String string2, String string3);
	
	Integer counttFloatingRatio(@Param(value = "assignjfsfqDayTabName") String assignjfsfqDayTabName,@Param(value = "assignYestoyyyymmddday") String assignYestoyyyymmddday,@Param(value = "floSt") String floSt,@Param(value = "bussTp") String bussTp);

	List<TblCqpntPointOutFlowEnyity> selectTheTopFiftyTheConversionValueRatioOfPointsIsNotSingleNumber(@Param(value = "jfsfzDayTabName") String jfsfzDayTabName,@Param(value = "yestoyyyymmddday") String yestoyyyymmddday,@Param(value = "floSt") String floSt);

}
